package src.lshz.servlet;

import src.lshz.JdbcUtils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;


@WebServlet(urlPatterns = "/user/lshzadd")
public class UserAddServlet extends HttpServlet {
	private src.lshz.JdbcUtils JdbcUtils;

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// 1. 取值
		String name = req.getParameter("n");
		String username = req.getParameter("u");
		String id = req.getParameter("i");
		// 2. 储值
		if (id != null && !"null".equals(id)) {
			// 存在 id，执行更新
			String sql = "UPDATE `user` SET `name` = ?, username = ? WHERE id = ?";
			JdbcUtils.modify(sql, name, username, id);
		} else {
			// 存在 id，执行插入
			String sql = "INSERT INTO `user` (username, `password`, `name`) VALUES(?, MD5('666666'), ?)";
			JdbcUtils.modify(sql, username, name);
		}
		// 3. 跳转
		resp.sendRedirect("/lshz/user-list.jsp");
	}
}
